Advanced SQL Joins and Subqueries